Tabela MealType

Definicja tabeli MealType

Name

MealType

Code

MealType

Comment

Typy posilków takie jak: sniadanie, obiad, kolacja itp. oraz ich ramy czasowe (StartT i StopT


Lista kolumn tabeli MealType

Name

Code

MealTypeID

MealTypeID

StartT

StartT

StopT

StopT

Active

Active

OrderStopT

OrderStopT

OrderCorrectT

OrderCorrectT


Kolumna MealTypeID tabeli MealType

Definicja kolumny MealTypeID tabeli MealType

Name

MealTypeID

Code

MealTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartT tabeli MealType

Definicja kolumny StartT tabeli MealType

Name

StartT

Code

StartT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopT tabeli MealType

Definicja kolumny StopT tabeli MealType

Name

StopT

Code

StopT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli MealType

Definicja kolumny Active tabeli MealType

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna OrderStopT tabeli MealType

Definicja kolumny OrderStopT tabeli MealType

Name

OrderStopT

Code

OrderStopT

Data Type

DATE

Mandatory

No

Comment

Czas do którego mozna zamawiac posilek


Kolumna OrderCorrectT tabeli MealType

Definicja kolumny OrderCorrectT tabeli MealType

Name

OrderCorrectT

Code

OrderCorrectT

Data Type

DATE

Mandatory

No

Comment

Czas do którego mozna wykonac korekte zamówienia


Lista kluczy tabeli MealType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MealType

Definicja klucza Identifier_1 tabeli MealType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment